﻿USE HealthcareClaims
TRUNCATE TABLE LookupValues
GO
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'aa', N'Received new 837 claim from external system', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ab', N'Sent 837 claim to external validator prior to posting to payer', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ac', N'Received level 7 validated 837 claim from external validator', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ad', N'Sent 837 claim to failed validation step', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ae', N'Sent validated 837 claim to external party for payment', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'af', N'Received 835 notification from payer', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ag', N'Sent 835 claim to external validator prior to posting to external system', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ah', N'Received level 7 validated 835 claim from external validator', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ai', N'Sent 835 claim to failed validation step', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'af', N'Sent 276 status request to payer', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ag', N'Received 277 status response from payer', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'', N'', N'')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WW0000X', N' Wound Care', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WW0101X', N' Women''s Health Care, Ambulatory', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WX0002X', N' Obstetric, High-Risk', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WX0003X', N' Obstetric, Inpatient', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WX0106X', N' Occupational Health', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WX0200X', N' Oncology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WX0601X', N' Otorhinolaryngology & Head-Neck', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WX0800X', N' Orthopedic', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WX1100X', N' Ophthalmic', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WX1500X', N' Ostomy Care', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'164W00000X', N' Licensed Practical Nurse', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'164X00000X', N' Licensed Vocational Nurse', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'167G00000X', N' Licensed Psychiatric Technician', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'170100000X', N' Ph.D. Medical Genetics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'170300000X', N' Genetic Counselor, MS', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'171000000X', N' Military Health Care Provider', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1710I1002X', N' Independent Duty Corpsman', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1710I1003X', N' Independent Duty Medical Technicians', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'171100000X', N' Acupuncturist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'171W00000X', N' Contractor', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207Q00000X', N' Family Practice', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207QA0000X', N' Adolescent Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207QA0401X', N' Addiction Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207QA0505X', N' Adult Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207QG0300X', N' Geriatric Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207QS0010X', N' Sports Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207R00000X', N' Internal Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RA0000X', N' Adolescent Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RA0201X', N' Allergy & Immunology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RA0401X', N' Addiction Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RC0000X', N' Cardiovascular Disease', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RC0001X', N' Clinical Cardiac Electrophysiology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RC0200X', N' Critical Care Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RE0101X', N' Endocrinology, Diabetes & Metabolism', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RG0100X', N' Gastroenterology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RG0300X', N' Geriatric Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RH0000X', N' Hematology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RH0003X', N' Hematology & Oncology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RI0001X', N' Clinical & Laboratory Immunology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RI0008X', N' Hepatology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RI0011X', N' Interventional Cardiology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RI0200X', N' Infectious Disease', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RM1200X', N' Magnetic Resonance Imaging (MRI)', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RN0300X', N' Nephrology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RP1001X', N' Pulmonary Disease', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RR0500X', N' Rheumatology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RS0010X', N' Sports Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207RX0202X', N' Medical Oncology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207SC0300X', N' Clinical Cytogenetics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207SG0201X', N' Clinical Genetics (M.D.)', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207SG0202X', N' Clinical Biochemical Genetics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207SG0203X', N' Clinical Molecular Genetics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207SG0205X', N' Ph.D. Medical Genetics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207SM0001X', N' Molecular Genetic Pathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207T00000X', N' Neurological Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207U00000X', N' Nuclear Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207UN0901X', N' Nuclear Cardiology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207UN0902X', N' Nuclear Imaging & Therapy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207UN0903X', N' In Vivo & In Vitro Nuclear Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207V00000X', N' Obstetrics & Gynecology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207VC0200X', N' Critical Care Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207VE0102X', N' Reproductive Endocrinology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207VG0400X', N' Gynecology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207VM0101X', N' Maternal & Fetal Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207VX0000X', N' Obstetrics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207VX0201X', N' Gynecologic Oncology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207W00000X', N' Ophthalmology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207X00000X', N' Orthopaedic Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207XS0106X', N' Hand Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207XS0114X', N' Adult Reconstructive Orthopaedic Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207XS0117X', N' Orthopaedic Surgery of the Spine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207XX0004X', N' Foot and Ankle Orthopaedics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207XX0005X', N' Sports Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207XX0801X', N' Orthopaedic Trauma', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207Y00000X', N' Otolaryngology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207YP0228X', N' Pediatric Otolaryngology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207YS0123X', N' Facial Plastic Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207YX0007X', N' Plastic Surgery within the Head & Neck', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207YX0602X', N' Otolaryngic Allergy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207YX0901X', N' Otology & Neurotology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207YX0905X', N' Otolaryngology/Facial Plastic Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZB0001X', N' Blood Banking & Transfusion Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZC0500X', N' Cytopathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZD0900X', N' Dermatopathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZF0201X', N' Forensic Pathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZH0000X', N' Hematology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZI0100X', N' Immunopathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZM0300X', N' Medical Microbiology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZN0500X', N' Neuropathology', N'ProviderTaxonomyCode')
GO
print 'Processed 100 total records'
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZP0007X', N' Molecular Genetic Pathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZP0101X', N' Anatomic Pathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZP0102X', N' Anatomic Pathology & Clinical Pathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZP0104X', N' Chemical Pathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZP0105X', N' Clinical Pathology/Laboratory Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ZP0213X', N' Pediatric Pathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'208000000X', N' Pediatrics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2080A0000X', N' Adolescent Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2080I0007X', N' Clinical & Laboratory Immunology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2080N0001X', N' Neonatal-Perinatal Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2080P0006X', N' Developmental ', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'133VN1005X', N' Nutrition, Renal', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'133VN1006X', N' Nutrition, Metabolic', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'136A00000X', N' Dietetic Technician, Registered', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'146D00000X', N' Personal Emergency Response Attendant', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'146L00000X', N' Emergency Medical Technician, Paramedic', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'146M00000X', N' Emergency Medical Technician, Intermediate', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'146N00000X', N' Emergency Medical Technician, Basic', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'152W00000X', N' Optometrist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'152WC0802X', N' Corneal and Contact Management', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'152WL0500X', N' Low Vision Rehabilitation', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'152WP0200X', N' Pediatrics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'152WS0006X', N' Sports Vision', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'152WV0400X', N' Vision Therapy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'152WX0102X', N' Occupational Vision', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156F00000X', N' Technician/Technologist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156FC0800X', N' Contact Lens', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156FC0801X', N' Contact Lens Fitter', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156FX1100X', N' Ophthalmic', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156FX1101X', N' Ophthalmic Assistant', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156FX1201X', N' Optometric Assistant', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156FX1202X', N' Optometric Technician', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156FX1700X', N' Ocularist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156FX1800X', N' Optician', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156FX1900X', N' Orthoptist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163W00000X', N' Registered Nurse', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WA0400X', N' Addiction (Substance Use Disorder)', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WA2000X', N' Administrator', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WC0200X', N' Critical Care Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WC0400X', N' Case Management', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WC1400X', N' College Health', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WC1500X', N' Community Health', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WC1600X', N' Continuing Education/Staff Development', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WC2100X', N' Continence Care', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WC3500X', N' Cardiac Rehabilitation', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WD0400X', N' Diabetes Educator', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WD1100X', N' Dialysis, Peritoneal', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WE0003X', N' Emergency', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WE0900X', N' Enterostomal Therapy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WF0300X', N' Flight', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WG0000X', N' General Practice', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WG0100X', N' Gastroenterology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WG0600X', N' Gerontology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WH0200X', N' Home Health', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WH0500X', N' Hemodialysis', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WH1000X', N' Hospice', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WI0500X', N' Infusion Therapy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WI0600X', N' Infection Control', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WL0100X', N' Lactation Consultant', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WM0102X', N' Maternal Newborn', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WM0705X', N' Medical-Surgical', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WM1400X', N' Nurse Massage Therapist (NMT)', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WN0002X', N' Neonatal Intensive Care', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'171WH0202X', N' Home Modifications', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'171WV0202X', N' Vehicle Modifications', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'172A00000X', N' Driver', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'173000000X', N' Legal Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'174400000X', N' Specialist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1744G0900X', N' Graphics Designer', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1744P3200X', N' Prosthetics Case Management', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1744R1102X', N' Research Study', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1744R1103X', N' Research Data Abstracter/Coder', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'174M00000X', N' Veterinarian', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'174MM1900X', N' Medical Research', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'175F00000X', N' Naturopath', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'175L00000X', N' Homeopath', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'175M00000X', N' Midwife, Lay', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'176B00000X', N' Midwife, Certified', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'176P00000X', N' Funeral Director', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'177F00000X', N' Lodging', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'183500000X', N' Pharmacist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1835N0905X', N' Nuclear Pharmacy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1835N1003X', N' Nutrition Support', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1835P1200X', N' Pharmacotherapy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1835P1300X', N' Psychopharmacy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'183700000X', N' Pharmacy Technician', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'193200000X', N' Multi-Specialty', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'193400000X', N' Single Specialty', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'204C00000X', N' Neuromusculoskeletal Medicine, Sports Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'204D00000X', N' Neuromusculoskeletal Medicine & OMM', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'204E00000X', N' Oral & Maxillofacial Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'204F00000X', N' Transplant Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207K00000X', N' Allergy & Immunology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207KA0200X', N' Allergy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207KI0005X', N' Clinical & Laboratory Immunology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207L00000X', N' Anesthesiology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207LA0401X', N' Addiction Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207LC0200X', N' Critical Care Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207LP2900X', N' Pain Mediciine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207N00000X', N' Dermatology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ND0101X', N' MOHS-Micrographic Surgery', N'ProviderTaxonomyCode')
GO
print 'Processed 200 total records'
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207ND0900X', N' Dermatopathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207NI0002X', N' Clinical & Laboratory Dermatological Immunology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207NP0225X', N' Pediatric Dermatology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207NS0135X', N' Dermatological Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207P00000X', N' Emergency Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207PE0004X', N' Emergency Medical Services', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207PE0005X', N' Undersea and Hyperbaric Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207PP0204X', N' Pediatric Emergency Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207PS0010X', N' Sports Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207PT0002X', N' Medical Toxicology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'84', N'MAJOR CHEST TRAUMA W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'85', N'PLEURAL EFFUSION W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'86', N'PLEURAL EFFUSION W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'87', N'PULMONARY EDEMA & RESPIRATORY FAILURE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'88', N'CHRONIC OBSTRUCTIVE PULMONARY DISEASE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'5', N'Pended', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'6', N'Approved as amended', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'7', N'Approved as submitted', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'8', N'Cancelled due to inactivity', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'9', N'Pending - under investigation', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'AD', N'Additional', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'AP', N'Appealed', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'CC', N'Weekly Certification', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'CL', N'Closed', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'CP', N'Open', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'I', N'Initial', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'RA', N'Reaudited', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'RB', N'Reissue', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'RC', N'Reopened and Closed', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'RD', N'Redetermination', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'RO', N'Reopened', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'', N'', N'')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'101Y00000X', N' Counselor', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'101YA0400X', N' Addiction (Substance Use Disorder)', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'101YM0800X', N' Mental Health', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'101YP1600X', N' Pastoral', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'101YP2500X', N' Professional', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'101YS0200X', N' School', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103G00000X', N' Neuropsychologist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103GC0700X', N' Clinical', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103T00000X', N' Psychologist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TA0400X', N' Addiction (Substance Use Disorder)', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TA0700X', N' Adult Development & Aging', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TB0200X', N' Behavioral', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TC0700X', N' Clinical', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TC1900X', N' Counseling', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TC2200X', N' Child, Youth & Family', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TE1000X', N' Educational', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TE1100X', N' Exercise & Sports', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TF0000X', N' Family', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TF0200X', N' Forensic', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TH0100X', N' Health', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TM1700X', N' Men & Masculinity', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TM1800X', N' Mental Retardation & Developmental Disabilities', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TP0814X', N' Psychoanalysis', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TP2700X', N' Psychotherapy', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TP2701X', N' Psychotherapy, Group', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TR0400X', N' Rehabilitation', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TS0200X', N' School', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103TW0100X', N' Women', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'104100000X', N' Social Worker', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1041C0700X', N' Clinical', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1041S0200X', N' School', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'106H00000X', N' Marriage & Family Therapist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111N00000X', N' Chiropractor', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111NI0900X', N' Internist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111NN0400X', N' Neurology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111NN1001X', N' Nutrition', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111NR0200X', N' Radiology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111NS0005X', N' Sports Physician', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111NT0100X', N' Thermography', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111NX0100X', N' Occupational Medicine', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111NX0800X', N' Orthopedic', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'122300000X', N' Dentist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223D0001X', N' Dental Public Health', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223E0200X', N' Endodontics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223G0001X', N' General Practice', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223P0106X', N' Oral and Maxillofacial Pathology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223P0221X', N' Pediatric Dentistry', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223P0300X', N' Periodontics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223P0700X', N' Prosthodontics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223S0112X', N' Oral and Maxillofacial Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223X0008X', N' Oral and Maxillofacial Radiology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1223X0400X', N' Orthodontics and Dentofacial Orthopedics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'122400000X', N' Denturist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'124Q00000X', N' Dental Hygienist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'126800000X', N' Dental Assistant', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'126900000X', N' Dental Laboratory Technician', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'132700000X', N' Dietary Manager', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'133N00000X', N' Nutritionist', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'133NN1002X', N' Nutrition, Education', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'133V00000X', N' Dietitian, Registered', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'133VN1004X', N' Nutrition, Pediatric', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WN0003X', N' Neonatal, Low-Risk', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WN0300X', N' Nephrology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WN0800X', N' Neuroscience', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WN1003X', N' Nutrition Support', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WP0000X', N' Pain Management', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WP0200X', N' Pediatrics', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WP0218X', N' Pediatric Oncology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WP0807X', N' Psychiatric/Mental Health, Child & Adolescent', N'ProviderTaxonomyCode')
GO
print 'Processed 300 total records'
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WP0808X', N' Psychiatric/Mental Health', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WP0809X', N' Psychiatric/Mental Health, Adult', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WP1700X', N' Perinatal', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WP2201X', N' Ambulatory Care', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WR0400X', N' Rehabilitation', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WR1000X', N' Reproductive Endocrinology/Infertility', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WS0121X', N' Plastic Surgery', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WS0200X', N' School', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163WU0100X', N' Urology', N'ProviderTaxonomyCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'528', N'INTRACRANIAL VASCULAR PROC W PDX HEMORRHAGE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'529', N'VENTRICULAR SHUNT PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'53', N'SINUS & MASTOID PROCEDURES AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'530', N'VENTRICULAR SHUNT PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'531', N'SPINAL PROCEDURES W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'532', N'SPINAL PROCEDURES W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'533', N'EXTRACRANIAL PROCEDURES W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'534', N'EXTRACRANIAL PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'535', N'CARDIAC DEFIB IMPLANT W CARDIAC CATH W AMI/HF/SHOCK.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'536', N'CARDIAC DEFIB IMPLANT W CARDIAC CATH W/O AMI/HF/SHOCK.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'537', N'LOCAL EXCIS & REMOV OF INT FIX DEV EXCEPT HIP & FEMUR W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'538', N'LOCAL EXCIS & REMOV OF INT FIX DEV EXCEPT HIP & FEMUR W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'539', N'LYMPHOMA & LEUKEMIA W MAJOR OR PROCEDURE W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'54', N'SINUS & MASTOID PROCEDURES AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'540', N'LYMPHOMA & LEUKEMIA W MAJOR OR PROCEDURE W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'541', N'ECMO OR TRACH W MV 96+HRS OR PDX EXC FACE, MOUTH & NECK W MAJ O.R..', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'542', N'TRACH W MV 96+HRS OR PDX EXC FACE, MOUTH & NECK W/O MAJ O.R..', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'543', N'CRANIOTOMY W/IMPLANT OF CHEMO AGENT OR ACUTE COMPLX CNS PDX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'544', N'MAJOR JOINT REPLACEMENT OR REATTACHMENT OF LOWER EXTREMITY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'545', N'REVISION OF HIP OR KNEE REPLACEMENT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'546', N'SPINAL FUSION EXC CERV WITH CURVATURE OF THE SPINE OR MALIG.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'547', N'CORONARY BYPASS W CARDIAC CATH W MAJOR CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'548', N'CORONARY BYPASS W CARDIAC CATH W/O MAJOR CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'549', N'CORONARY BYPASS W/O CARDIAC CATH W MAJOR CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'55', N'MISCELLANEOUS EAR, NOSE, MOUTH & THROAT PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'550', N'CORONARY BYPASS W/O CARDIAC CATH W/O MAJOR CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'551', N'PERMANENT CARDIAC PACEMAKER IMPL W MAJ CV DX OR AICD LEAD OR GNRTR.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'552', N'OTHER PERMANENT CARDIAC PACEMAKER IMPLANT W/O MAJOR CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'553', N'OTHER VASCULAR PROCEDURES W CC W MAJOR CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'554', N'OTHER VASCULAR PROCEDURES W CC W/O MAJOR CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'555', N'PERCUTANEOUS CARDIOVASCULAR PROC W MAJOR CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'556', N'PERCUTANEOUS CARDIOVASC PROC W NON-DRUG-ELUTING STENT W/O MAJ CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'557', N'PERCUTANEOUS CARDIOVASCULAR PROC W DRUG-ELUTING STENT W MAJOR CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'558', N'PERCUTANEOUS CARDIOVASCULAR PROC W DRUG-ELUTING STENT W/O MAJ CV DX.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'89', N'SIMPLE PNEUMONIA & PLEURISY AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'9', N'SPINAL DISORDERS & INJURIES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'90', N'SIMPLE PNEUMONIA & PLEURISY AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'91', N'SIMPLE PNEUMONIA & PLEURISY AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'92', N'INTERSTITIAL LUNG DISEASE W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'93', N'INTERSTITIAL LUNG DISEASE W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'94', N'PNEUMOTHORAX W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'95', N'PNEUMOTHORAX W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'96', N'BRONCHITIS & ASTHMA AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'97', N'BRONCHITIS & ASTHMA AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'98', N'BRONCHITIS & ASTHMA AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'99', N'RESPIRATORY SIGNS & SYMPTOMS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'A', N'Accepted', N'StatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'R', N'Rejected', N'StatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'P', N'Partial Accepted', N'StatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'0', N'Non-Payment/Zero Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1', N'Admit thru Discharge Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2', N'Interim - First Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'3', N'Interim - Continuing Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'4', N'Interim - Last Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'5', N'Late Charge(s) Only Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'7', N'Replacement of Prior Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'8', N'Void/Cancel of Prior Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'9', N'Final Claim for a Home Health PPS Episode', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'A', N'Admission/Election Notice ', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'B', N'Hospice/Medicare Coordinated Care Demonstration/Religious Non-Medical Health Care Institution/Centers of Excellence Demonstration/Provider Partnerships Demonstration - Termination/Revocation Notice ', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'C', N'Hospice Change of Provider Notice', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'D', N'Hospice/Medicare Coordinated Care Demonstration/Religious Non-Medical Health Care Institution Institution/Centers of Excellence Demonstration/Provider Partnerships Demonstration - Void/Cancel (a)', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'E', N'Hospice Change of Ownership', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'F', N'Beneficiary Initiated Adjustment Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'G', N'CWF Initiated Adjustment Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'H', N'HCFA Initiated Adjustment Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'I', N'Intermediary Adjustment Claim (Other Than Pro or Provider)', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'J', N'Initiated Adjustment Claim - Other', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'K', N'OIG Initiated Adjustment Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'M', N'MSP Initiated Adjustment Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'N', N'PRO Adjustment Claim', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'O', N'Nonpayment/Zero Claims', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'X', N'Void/Cancel a Prior Abbreviated Encounter Submission', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'Y', N'Replacement of Prior Abbreviated Encounter Submission', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'Z', N'New Abbreviated Encounter Submission', N'ClaimFrequency')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1', N'Processed as Primary', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'10', N'Received, but not in process', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'11', N'Rejected, duplicate claim', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'12', N'Rejected, please resubmit with corrections', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'13', N'Suspended', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'14', N'Suspended - incomplete claim', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'15', N'Suspended - investigation with field', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'16', N'Suspended - return with material', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'17', N'Suspended - review pending', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'18', N'Suspended Product Registration', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'19', N'Processed as Primary, Forwarded to Additional Payer(s)', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2', N'Processed as Secondary', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'20', N'Processed as Secondary, Forwarded to Additional Payer(s)', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'21', N'Processed as Tertiary, Forwarded to Additional Payer(s)', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'22', N'Reversal of Previous Payment', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'23', N'Not Our Claim, Forwarded to Additional Payer(s)', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'24', N'Transferred to Proper Carrier', N'ClaimStatusCode')
GO
print 'Processed 400 total records'
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'25', N'Predetermination Pricing Only - No Payment', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'26', N'Documentation Claim - No Payment Associated', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'27', N'Reviewed', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'28', N'Repriced', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'29', N'Audited', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'3', N'Processed as Tertiary', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'30', N'Processed as Conditional', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'4', N'Denied', N'ClaimStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'466', N'AFTERCARE W/O HISTORY OF MALIGNANCY AS SECONDARY DIAGNOSIS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'467', N'OTHER FACTORS INFLUENCING HEALTH STATUS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'468', N'EXTENSIVE O.R. PROCEDURE UNRELATED TO PRINCIPAL DIAGNOSIS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'469', N'PRINCIPAL DIAGNOSIS INVALID AS DISCHARGE DIAGNOSIS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'47', N'OTHER DISORDERS OF THE EYE AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'470', N'UNGROUPABLE', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'471', N'BILATERAL OR MULTIPLE MAJOR JOINT PROCS OF LOWER EXTREMITY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'472', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'473', N'ACUTE LEUKEMIA W/O MAJOR O.R. PROCEDURE AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'474', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'475', N'RESPIRATORY SYSTEM DIAGNOSIS WITH VENTILATOR SUPPORT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'476', N'PROSTATIC O.R. PROCEDURE UNRELATED TO PRINCIPAL DIAGNOSIS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'477', N'NON-EXTENSIVE O.R. PROCEDURE UNRELATED TO PRINCIPAL DIAGNOSIS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'478', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'479', N'OTHER VASCULAR PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'48', N'OTHER DISORDERS OF THE EYE AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'480', N'LIVER TRANSPLANT AND/OR INTESTINAL TRANSPLANT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'481', N'BONE MARROW TRANSPLANT', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'482', N'TRACHEOSTOMY FOR FACE,MOUTH & NECK DIAGNOSES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'483', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'484', N'CRANIOTOMY FOR MULTIPLE SIGNIFICANT TRAUMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'485', N'LIMB REATTACHMENT, HIP AND FEMUR PROC FOR MULTIPLE SIGNIFICANT TRA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'486', N'OTHER O.R. PROCEDURES FOR MULTIPLE SIGNIFICANT TRAUMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'487', N'OTHER MULTIPLE SIGNIFICANT TRAUMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'488', N'HIV W EXTENSIVE O.R. PROCEDURE', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'489', N'HIV W MAJOR RELATED CONDITION', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'49', N'MAJOR HEAD & NECK PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'490', N'HIV W OR W/O OTHER RELATED CONDITION.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'491', N'MAJOR JOINT & LIMB REATTACHMENT PROCEDURES OF UPPER EXTREMITY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'492', N'CHEMOTHERAPY W ACUTE LEUKEMIA OR W USE OF HI DOSE CHEMOAGENT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'493', N'LAPAROSCOPIC CHOLECYSTECTOMY W/O C.D.E. W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'494', N'LAPAROSCOPIC CHOLECYSTECTOMY W/O C.D.E. W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'495', N'LUNG TRANSPLANT', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'496', N'COMBINED ANTERIOR/POSTERIOR SPINAL FUSION.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'497', N'SPINAL FUSION EXCEPT CERVICAL W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'498', N'SPINAL FUSION EXCEPT CERVICAL W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'499', N'BACK & NECK PROCEDURES EXCEPT SPINAL FUSION W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'5', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'50', N'SIALOADENECTOMY', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'500', N'BACK & NECK PROCEDURES EXCEPT SPINAL FUSION W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'501', N'KNEE PROCEDURES W PDX OF INFECTION W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'502', N'KNEE PROCEDURES W PDX OF INFECTION W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'503', N'KNEE PROCEDURES W/O PDX OF INFECTION.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'504', N'EXTEN. BURNS OR FULL THICKNESS BURN W/MV 96+HRS W/SKIN GFT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'505', N'EXTEN. BURNS OR FULL THICKNESS BURN W/MV 96+HRS W/O SKIN GFT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'506', N'FULL THICKNESS BURN W SKIN GRAFT OR INHAL INJ W CC OR SIG TRAUMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'507', N'FULL THICKNESS BURN W SKIN GRFT OR INHAL INJ W/O CC OR SIG TRAUMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'508', N'FULL THICKNESS BURN W/O SKIN GRFT OR INHAL INJ W CC OR SIG TRAUMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'509', N'FULL THICKNESS BURN W/O SKIN GRFT OR INH INJ W/O CC OR SIG TRAUMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'51', N'SALIVARY GLAND PROCEDURES EXCEPT SIALOADENECTOMY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'510', N'NON-EXTENSIVE BURNS W CC OR SIGNIFICANT TRAUMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'511', N'NON-EXTENSIVE BURNS W/O CC OR SIGNIFICANT TRAUMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'512', N'SIMULTANEOUS PANCREAS/KIDNEY TRANSPLANT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'513', N'PANCREAS TRANSPLANT', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'514', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'515', N'CARDIAC DEFIBRILLATOR IMPLANT W/O CARDIAC CATH.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'516', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'517', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'518', N'PERC CARDIO PROC W/O CORONARY ARTERY STENT OR AMI.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'519', N'CERVICAL SPINAL FUSION W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'52', N'CLEFT LIP & PALATE REPAIR', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'520', N'CERVICAL SPINAL FUSION W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'521', N'ALCOHOL/DRUG ABUSE OR DEPENDENCE W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'522', N'ALC/DRUG ABUSE OR DEPEND W REHABILITATION THERAPY W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'523', N'ALC/DRUG ABUSE OR DEPEND W/O REHABILITATION THERAPY W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'524', N'TRANSIENT ISCHEMIA', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'525', N'OTHER HEART ASSIST SYSTEM IMPLANT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'526', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'559', N'ACUTE ISCHEMIC STROKE WITH USE OF THROMBOLYTIC AGENT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'56', N'RHINOPLASTY', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'57', N'T&A PROC, EXCEPT TONSILLECTOMY &/OR ADENOIDECTOMY ONLY, AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'58', N'T&A PROC, EXCEPT TONSILLECTOMY &/OR ADENOIDECTOMY ONLY, AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'59', N'TONSILLECTOMY &/OR ADENOIDECTOMY ONLY, AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'6', N'CARPAL TUNNEL RELEASE', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'60', N'TONSILLECTOMY &/OR ADENOIDECTOMY ONLY, AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'61', N'MYRINGOTOMY W TUBE INSERTION AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'62', N'MYRINGOTOMY W TUBE INSERTION AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'63', N'OTHER EAR, NOSE, MOUTH & THROAT O.R. PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'64', N'EAR, NOSE, MOUTH & THROAT MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'65', N'DYSEQUILIBRIUM', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'66', N'EPISTAXIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'67', N'EPIGLOTTITIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'68', N'OTITIS MEDIA & URI AGE &gt;17 W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'69', N'OTITIS MEDIA & URI AGE &gt;17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'7', N'PERIPH & CRANIAL NERVE & OTHER NERV SYST PROC W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'70', N'OTITIS MEDIA & URI AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'71', N'LARYNGOTRACHEITIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'72', N'NASAL TRAUMA & DEFORMITY', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'73', N'OTHER EAR, NOSE, MOUTH & THROAT DIAGNOSES AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'74', N'OTHER EAR, NOSE, MOUTH & THROAT DIAGNOSES AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'75', N'MAJOR CHEST PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'76', N'OTHER RESP SYSTEM O.R. PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'77', N'OTHER RESP SYSTEM O.R. PROCEDURES W/O CC.', N'DRGCode')
GO
print 'Processed 500 total records'
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'78', N'PULMONARY EMBOLISM', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'79', N'RESPIRATORY INFECTIONS & INFLAMMATIONS AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'8', N'PERIPH & CRANIAL NERVE & OTHER NERV SYST PROC W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'80', N'RESPIRATORY INFECTIONS & INFLAMMATIONS AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'81', N'RESPIRATORY INFECTIONS & INFLAMMATIONS AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'82', N'RESPIRATORY NEOPLASMS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'83', N'MAJOR CHEST TRAUMA W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'334', N'MAJOR MALE PELVIC PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'335', N'MAJOR MALE PELVIC PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'336', N'TRANSURETHRAL PROSTATECTOMY W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'337', N'TRANSURETHRAL PROSTATECTOMY W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'338', N'TESTES PROCEDURES, FOR MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'339', N'TESTES PROCEDURES, NON-MALIGNANCY AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'34', N'OTHER DISORDERS OF NERVOUS SYSTEM W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'340', N'TESTES PROCEDURES, NON-MALIGNANCY AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'341', N'PENIS PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'342', N'CIRCUMCISION AGE >17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'343', N'CIRCUMCISION AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'344', N'OTHER MALE REPRODUCTIVE SYSTEM O.R. PROCEDURES FOR MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'345', N'OTHER MALE REPRODUCTIVE SYSTEM O.R. PROC EXCEPT FOR MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'346', N'MALIGNANCY, MALE REPRODUCTIVE SYSTEM, W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'347', N'MALIGNANCY, MALE REPRODUCTIVE SYSTEM, W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'348', N'BENIGN PROSTATIC HYPERTROPHY W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'349', N'BENIGN PROSTATIC HYPERTROPHY W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'35', N'OTHER DISORDERS OF NERVOUS SYSTEM W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'350', N'INFLAMMATION OF THE MALE REPRODUCTIVE SYSTEM.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'351', N'STERILIZATION, MALE', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'352', N'OTHER MALE REPRODUCTIVE SYSTEM DIAGNOSES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'353', N'PELVIC EVISCERATION, RADICAL HYSTERECTOMY & RADICAL VULVECTOMY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'354', N'UTERINE,ADNEXA PROC FOR NONOVARIAN/ ADNEXAL MALIG W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'398', N'RETICULOENDOTHELIAL & IMMUNITY DISORDERS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'399', N'RETICULOENDOTHELIAL & IMMUNITY DISORDERS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'4', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'40', N'EXTRAOCULAR PROCEDURES EXCEPT ORBIT AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'400', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'401', N'LYMPHOMA & NON-ACUTE LEUKEMIA W OTHER O.R. PROC W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'402', N'LYMPHOMA & NON-ACUTE LEUKEMIA W OTHER O.R. PROC W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'403', N'LYMPHOMA & NON-ACUTE LEUKEMIA W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'404', N'LYMPHOMA & NON-ACUTE LEUKEMIA W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'405', N'ACUTE LEUKEMIA W/O MAJOR O.R. PROCEDURE AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'406', N'MYELOPROLIF DISORD OR POORLY DIFF NEOPL W MAJ O.R.PROC W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'407', N'MYELOPROLIF DISORD OR POORLY DIFF NEOPL W MAJ O.R.PROC W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'408', N'MYELOPROLIF DISORD OR POORLY DIFF NEOPL W OTHER O.R.PROC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'409', N'RADIOTHERAPY', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'41', N'EXTRAOCULAR PROCEDURES EXCEPT ORBIT AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'410', N'CHEMOTHERAPY W/O ACUTE LEUKEMIA AS SECONDARY DIAGNOSIS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'411', N'HISTORY OF MALIGNANCY W/O ENDOSCOPY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'412', N'HISTORY OF MALIGNANCY W ENDOSCOPY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'413', N'OTHER MYELOPROLIF DIS OR POORLY DIFF NEOPL DIAG W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'414', N'OTHER MYELOPROLIF DIS OR POORLY DIFF NEOPL DIAG W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'415', N'O.R. PROCEDURE FOR INFECTIOUS & PARASITIC DISEASES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'416', N'SEPTICEMIA AGE >17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'417', N'SEPTICEMIA AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'418', N'POSTOPERATIVE & POST-TRAUMATIC INFECTIONS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'419', N'FEVER OF UNKNOWN ORIGIN AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'42', N'INTRAOCULAR PROCEDURES EXCEPT RETINA, IRIS & LENS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'420', N'FEVER OF UNKNOWN ORIGIN AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'421', N'VIRAL ILLNESS AGE >17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'422', N'VIRAL ILLNESS & FEVER OF UNKNOWN ORIGIN AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'423', N'OTHER INFECTIOUS & PARASITIC DISEASES DIAGNOSES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'424', N'O.R. PROCEDURE W PRINCIPAL DIAGNOSES OF MENTAL ILLNESS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'425', N'ACUTE ADJUSTMENT REACTION & PSYCHOSOCIAL DYSFUNCTION.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'426', N'DEPRESSIVE NEUROSES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'427', N'NEUROSES EXCEPT DEPRESSIVE', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'428', N'DISORDERS OF PERSONALITY & IMPULSE CONTROL.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'429', N'ORGANIC DISTURBANCES & MENTAL RETARDATION.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'43', N'HYPHEMA', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'430', N'PSYCHOSES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'431', N'CHILDHOOD MENTAL DISORDERS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'432', N'OTHER MENTAL DISORDER DIAGNOSES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'433', N'ALCOHOL/DRUG ABUSE OR DEPENDENCE, LEFT AMA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'434', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'435', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'436', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'437', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'438', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'439', N'SKIN GRAFTS FOR INJURIES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'44', N'ACUTE MAJOR EYE INFECTIONS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'440', N'WOUND DEBRIDEMENTS FOR INJURIES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'441', N'HAND PROCEDURES FOR INJURIES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'442', N'OTHER O.R. PROCEDURES FOR INJURIES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'443', N'OTHER O.R. PROCEDURES FOR INJURIES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'444', N'TRAUMATIC INJURY AGE >17 W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'445', N'TRAUMATIC INJURY AGE >17 W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'446', N'TRAUMATIC INJURY AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'447', N'ALLERGIC REACTIONS AGE >17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'448', N'ALLERGIC REACTIONS AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'449', N'POISONING & TOXIC EFFECTS OF DRUGS AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'45', N'NEUROLOGICAL EYE DISORDERS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'450', N'POISONING & TOXIC EFFECTS OF DRUGS AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'451', N'POISONING & TOXIC EFFECTS OF DRUGS AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'452', N'COMPLICATIONS OF TREATMENT W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'453', N'COMPLICATIONS OF TREATMENT W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'454', N'OTHER INJURY, POISONING & TOXIC EFFECT DIAG W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'455', N'OTHER INJURY, POISONING & TOXIC EFFECT DIAG W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'456', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'457', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'458', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'459', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'46', N'OTHER DISORDERS OF THE EYE AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'460', N'NO LONGER VALID', N'DRGCode')
GO
print 'Processed 600 total records'
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'461', N'O.R. PROC W DIAGNOSES OF OTHER CONTACT W HEALTH SERVICES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'462', N'REHABILITATION', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'463', N'SIGNS & SYMPTOMS W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'464', N'SIGNS & SYMPTOMS W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'465', N'AFTERCARE W HISTORY OF MALIGNANCY AS SECONDARY DIAGNOSIS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'527', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'268', N'SKIN, SUBCUTANEOUS TISSUE & BREAST PLASTIC PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'269', N'OTHER SKIN, SUBCUT TISS & BREAST PROC W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'27', N'TRAUMATIC STUPOR & COMA, COMA >1 HR.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'270', N'OTHER SKIN, SUBCUT TISS & BREAST PROC W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'271', N'SKIN ULCERS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'272', N'MAJOR SKIN DISORDERS W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'273', N'MAJOR SKIN DISORDERS W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'274', N'MALIGNANT BREAST DISORDERS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'275', N'MALIGNANT BREAST DISORDERS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'276', N'NON-MALIGNANT BREAST DISORDERS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'277', N'CELLULITIS AGE >17 W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'278', N'CELLULITIS AGE >17 W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'279', N'CELLULITIS AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'28', N'TRAUMATIC STUPOR & COMA, COMA <1 HR AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'280', N'TRAUMA TO THE SKIN, SUBCUT TISS & BREAST AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'281', N'TRAUMA TO THE SKIN, SUBCUT TISS & BREAST AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'282', N'TRAUMA TO THE SKIN, SUBCUT TISS & BREAST AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'283', N'MINOR SKIN DISORDERS W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'284', N'MINOR SKIN DISORDERS W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'285', N'AMPUTAT OF LOWER LIMB FOR ENDOCRINE, NUTRIT,& METABOL DISORDERS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'286', N'ADRENAL & PITUITARY PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'287', N'SKIN GRAFTS & WOUND DEBRID FOR ENDOC, NUTRIT & METAB DISORDERS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'288', N'O.R. PROCEDURES FOR OBESITY', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'289', N'PARATHYROID PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'29', N'TRAUMATIC STUPOR & COMA, COMA <1 HR AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'290', N'THYROID PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'291', N'THYROGLOSSAL PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'292', N'OTHER ENDOCRINE, NUTRIT & METAB O.R. PROC W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'293', N'OTHER ENDOCRINE, NUTRIT & METAB O.R. PROC W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'294', N'DIABETES AGE >35', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'295', N'DIABETES AGE 0-35', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'296', N'NUTRITIONAL & MISC METABOLIC DISORDERS AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'297', N'NUTRITIONAL & MISC METABOLIC DISORDERS AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'298', N'NUTRITIONAL & MISC METABOLIC DISORDERS AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'299', N'INBORN ERRORS OF METABOLISM', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'3', N'CRANIOTOMY AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'30', N'TRAUMATIC STUPOR & COMA, COMA <1 HR AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'300', N'ENDOCRINE DISORDERS W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'301', N'ENDOCRINE DISORDERS W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'302', N'KIDNEY TRANSPLANT', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'303', N'KIDNEY,URETER & MAJOR BLADDER PROCEDURES FOR NEOPLASM.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'304', N'KIDNEY,URETER & MAJOR BLADDER PROC FOR NON-NEOPL W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'305', N'KIDNEY,URETER & MAJOR BLADDER PROC FOR NON-NEOPL W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'306', N'PROSTATECTOMY W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'307', N'PROSTATECTOMY W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'308', N'MINOR BLADDER PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'309', N'MINOR BLADDER PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'31', N'CONCUSSION AGE >17 W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'310', N'TRANSURETHRAL PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'311', N'TRANSURETHRAL PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'312', N'URETHRAL PROCEDURES, AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'313', N'URETHRAL PROCEDURES, AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'314', N'URETHRAL PROCEDURES, AGE 0-17 0.5012 2.3 2.3', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'355', N'UTERINE,ADNEXA PROC FOR NONOVARIAN/ ADNEXAL MALIG W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'356', N'FEMALE REPRODUCTIVE SYSTEM RECONSTRUCTIVE PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'357', N'UTERINE & ADNEXA PROC FOR OVARIAN OR ADNEXAL MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'358', N'UTERINE & ADNEXA PROC FOR NONMALIGNANCY W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'359', N'UTERINE & ADNEXA PROC FOR NONMALIGNANCY W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'36', N'RETINAL PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'360', N'VAGINA, CERVIX & VULVA PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'361', N'LAPAROSCOPY & INCISIONAL TUBAL INTERRUPTION.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'362', N'ENDOSCOPIC TUBAL INTERRUPTION 0.3057 1.4 1.4', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'363', N'D&C, CONIZATION & RADIO-IMPLANT, FOR MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'364', N'D&C, CONIZATION EXCEPT FOR MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'365', N'OTHER FEMALE REPRODUCTIVE SYSTEM O.R. PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'366', N'MALIGNANCY, FEMALE REPRODUCTIVE SYSTEM W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'367', N'MALIGNANCY, FEMALE REPRODUCTIVE SYSTEM W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'368', N'INFECTIONS, FEMALE REPRODUCTIVE SYSTEM.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'369', N'MENSTRUAL & OTHER FEMALE REPRODUCTIVE SYSTEM DISORDERS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'37', N'ORBITAL PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'370', N'CESAREAN SECTION W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'371', N'CESAREAN SECTION W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'372', N'VAGINAL DELIVERY W COMPLICATING DIAGNOSES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'373', N'VAGINAL DELIVERY W/O COMPLICATING DIAGNOSES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'374', N'VAGINAL DELIVERY W STERILIZATION &/OR D&C.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'375', N'VAGINAL DELIVERY W O.R. PROC EXCEPT STERIL &/OR D&C.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'376', N'POSTPARTUM & POST ABORTION DIAGNOSES W/O O.R. PROCEDURE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'377', N'POSTPARTUM & POST ABORTION DIAGNOSES W O.R. PROCEDURE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'378', N'ECTOPIC PREGNANCY', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'379', N'THREATENED ABORTION', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'38', N'PRIMARY IRIS PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'380', N'ABORTION W/O D&C', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'381', N'ABORTION W D&C, ASPIRATION CURETTAGE OR HYSTEROTOMY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'382', N'FALSE LABOR', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'383', N'OTHER ANTEPARTUM DIAGNOSES W MEDICAL COMPLICATIONS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'384', N'OTHER ANTEPARTUM DIAGNOSES W/O MEDICAL COMPLICATIONS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'385', N'NEONATES, DIED OR TRANSFERRED TO ANOTHER ACUTE CARE FACILITY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'386', N'EXTREME IMMATURITY OR RESPIRATORY DISTRESS SYNDROME, NEONATE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'387', N'PREMATURITY W MAJOR PROBLEMS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'388', N'PREMATURITY W/O MAJOR PROBLEMS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'389', N'FULL TERM NEONATE W MAJOR PROBLEMS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'39', N'LENS PROCEDURES WITH OR WITHOUT VITRECTOMY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'390', N'NEONATE W OTHER SIGNIFICANT PROBLEMS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'391', N'NORMAL NEWBORN', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'392', N'SPLENECTOMY AGE >17', N'DRGCode')
GO
print 'Processed 700 total records'
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'393', N'SPLENECTOMY AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'394', N'OTHER O.R. PROCEDURES OF THE BLOOD AND BLOOD FORMING ORGANS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'395', N'RED BLOOD CELL DISORDERS AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'396', N'RED BLOOD CELL DISORDERS AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'397', N'COAGULATION DISORDERS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'149', N'MAJOR SMALL & LARGE BOWEL PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'15', N'NONSPECIFIC CVA & PRECEREBRAL OCCLUSION W/O INFARCT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'150', N'PERITONEAL ADHESIOLYSIS W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'151', N'PERITONEAL ADHESIOLYSIS W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'152', N'MINOR SMALL & LARGE BOWEL PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'153', N'MINOR SMALL & LARGE BOWEL PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'154', N'STOMACH, ESOPHAGEAL & DUODENAL PROCEDURES AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'155', N'STOMACH, ESOPHAGEAL & DUODENAL PROCEDURES AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'156', N'STOMACH, ESOPHAGEAL & DUODENAL PROCEDURES AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'157', N'ANAL & STOMAL PROCEDURES W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'158', N'ANAL & STOMAL PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'159', N'HERNIA PROCEDURES EXCEPT INGUINAL & FEMORAL AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'16', N'NONSPECIFIC CEREBROVASCULAR DISORDERS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'208', N'DISORDERS OF THE BILIARY TRACT W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'209', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'21', N'VIRAL MENINGITIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'210', N'HIP & FEMUR PROCEDURES EXCEPT MAJOR JOINT AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'211', N'HIP & FEMUR PROCEDURES EXCEPT MAJOR JOINT AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'212', N'HIP & FEMUR PROCEDURES EXCEPT MAJOR JOINT AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'213', N'AMPUTATION FOR MUSCULOSKELETAL SYSTEM & CONN TISSUE DISORDERS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'214', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'215', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'216', N'BIOPSIES OF MUSCULOSKELETAL SYSTEM & CONNECTIVE TISSUE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'217', N'WND DEBRID & SKN GRFT EXCEPT HAND,FOR MUSCSKELET & CONN TISS DIS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'218', N'LOWER EXTREM & HUMER PROC EXCEPT HIP,FOOT,FEMUR AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'219', N'LOWER EXTREM & HUMER PROC EXCEPT HIP,FOOT,FEMUR AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'22', N'HYPERTENSIVE ENCEPHALOPATHY', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'220', N'LOWER EXTREM & HUMER PROC EXCEPT HIP,FOOT,FEMUR AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'221', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'222', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'223', N'MAJOR SHOULDER/ELBOW PROC, OR OTHER UPPER EXTREMITY PROC W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'224', N'SHOULDER,ELBOW OR FOREARM PROC,EXC MAJOR JOINT PROC, W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'225', N'FOOT PROCEDURES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'226', N'SOFT TISSUE PROCEDURES W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'227', N'SOFT TISSUE PROCEDURES W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'228', N'MAJOR THUMB OR JOINT PROC,OR OTH HAND OR WRIST PROC W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'229', N'HAND OR WRIST PROC, EXCEPT MAJOR JOINT PROC, W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'23', N'NONTRAUMATIC STUPOR & COMA', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'230', N'LOCAL EXCISION & REMOVAL OF INT FIX DEVICES OF HIP & FEMUR.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'231', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'232', N'ARTHROSCOPY', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'233', N'OTHER MUSCULOSKELET SYS & CONN TISS O.R. PROC W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'234', N'OTHER MUSCULOSKELET SYS & CONN TISS O.R. PROC W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'235', N'FRACTURES OF FEMUR', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'236', N'FRACTURES OF HIP & PELVIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'237', N'SPRAINS, STRAINS, & DISLOCATIONS OF HIP, PELVIS & THIGH.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'238', N'OSTEOMYELITIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'239', N'PATHOLOGICAL FRACTURES & MUSCULOSKELETAL & CONN TISS MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'24', N'SEIZURE & HEADACHE AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'240', N'CONNECTIVE TISSUE DISORDERS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'241', N'CONNECTIVE TISSUE DISORDERS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'242', N'SEPTIC ARTHRITIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'243', N'MEDICAL BACK PROBLEMS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'244', N'BONE DISEASES & SPECIFIC ARTHROPATHIES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'245', N'BONE DISEASES & SPECIFIC ARTHROPATHIES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'246', N'NON-SPECIFIC ARTHROPATHIES', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'247', N'SIGNS & SYMPTOMS OF MUSCULOSKELETAL SYSTEM & CONN TISSUE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'248', N'TENDONITIS, MYOSITIS & BURSITIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'249', N'AFTERCARE, MUSCULOSKELETAL SYSTEM & CONNECTIVE TISSUE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'25', N'SEIZURE & HEADACHE AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'250', N'FX, SPRN, STRN & DISL OF FOREARM, HAND, FOOT AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'251', N'FX, SPRN, STRN & DISL OF FOREARM, HAND, FOOT AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'252', N'FX, SPRN, STRN & DISL OF FOREARM, HAND, FOOT AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'253', N'FX, SPRN, STRN & DISL OF UPARM,LOWLEG EX FOOT AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'254', N'FX, SPRN, STRN & DISL OF UPARM,LOWLEG EX FOOT AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'255', N'FX, SPRN, STRN & DISL OF UPARM,LOWLEG EX FOOT AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'256', N'OTHER MUSCULOSKELETAL SYSTEM & CONNECTIVE TISSUE DIAGNOSES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'257', N'TOTAL MASTECTOMY FOR MALIGNANCY W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'258', N'TOTAL MASTECTOMY FOR MALIGNANCY W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'259', N'SUBTOTAL MASTECTOMY FOR MALIGNANCY W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'26', N'SEIZURE & HEADACHE AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'260', N'SUBTOTAL MASTECTOMY FOR MALIGNANCY W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'261', N'BREAST PROC FOR NON-MALIGNANCY EXCEPT BIOPSY & LOCAL EXCISION.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'262', N'BREAST BIOPSY & LOCAL EXCISION FOR NON-MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'263', N'SKIN GRAFT &/OR DEBRID FOR SKN ULCER OR CELLULITIS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'264', N'SKIN GRAFT &/OR DEBRID FOR SKN ULCER OR CELLULITIS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'265', N'SKIN GRAFT &/OR DEBRID EXCEPT FOR SKIN ULCER OR CELLULITIS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'266', N'SKIN GRAFT &/OR DEBRID EXCEPT FOR SKIN ULCER OR CELLULITIS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'267', N'PERIANAL & PILONIDAL PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'315', N'OTHER KIDNEY & URINARY TRACT O.R. PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'316', N'RENAL FAILURE', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'317', N'ADMIT FOR RENAL DIALYSIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'318', N'KIDNEY & URINARY TRACT NEOPLASMS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'319', N'KIDNEY & URINARY TRACT NEOPLASMS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'32', N'CONCUSSION AGE >17 W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'320', N'KIDNEY & URINARY TRACT INFECTIONS AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'321', N'KIDNEY & URINARY TRACT INFECTIONS AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'322', N'KIDNEY & URINARY TRACT INFECTIONS AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'323', N'URINARY STONES W CC, &/OR ESW LITHOTRIPSY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'324', N'URINARY STONES W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'325', N'KIDNEY & URINARY TRACT SIGNS & SYMPTOMS AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'326', N'KIDNEY & URINARY TRACT SIGNS & SYMPTOMS AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'327', N'KIDNEY & URINARY TRACT SIGNS & SYMPTOMS AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'328', N'URETHRAL STRICTURE AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'329', N'URETHRAL STRICTURE AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'33', N'CONCUSSION AGE 0-17', N'DRGCode')
GO
print 'Processed 800 total records'
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'330', N'URETHRAL STRICTURE AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'331', N'OTHER KIDNEY & URINARY TRACT DIAGNOSES AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'332', N'OTHER KIDNEY & URINARY TRACT DIAGNOSES AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'333', N'OTHER KIDNEY & URINARY TRACT DIAGNOSES AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'MB', N'Medicare Part B', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'MC', N'Medicaid', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'MH', N'Managed Care Non-HMO', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'OF', N'Other Federal Program', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'SA', N'Self-administered Group', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'TV', N'Title V', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'VA', N'Veterans Affairs Plan', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'WB', N'Workers'' Compensation First Report of Injury', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'WC', N'Workers'' Compensation Health Claim', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'WD', N'Workers'' Compensation Subsequent Report of Injury', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'WE', N'Workers'' Compensation Combined First and Subsequent Report', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ZZ', N'Mutually Defined Unknown', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'18', N'Self', N'SubscriberRelationshipCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1', N'Person', N'SubscriberEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2', N'Non-Person Entity', N'SubscriberEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'MI', N'Member Identification Number', N'SubscriberPrimaryIDQual')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ZZ', N'Mutually Defined', N'SubscriberPrimaryIDQual')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'MI', N'Member Identification Number', N'PatientPrimaryIDQual')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ZZ', N'Mutually Defined', N'PatientPrimaryIDQual')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1', N'CRANIOTOMY AGE >17 W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'10', N'NERVOUS SYSTEM NEOPLASMS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'100', N'RESPIRATORY SIGNS & SYMPTOMS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'101', N'OTHER RESPIRATORY SYSTEM DIAGNOSES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'102', N'OTHER RESPIRATORY SYSTEM DIAGNOSES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'103', N'HEART TRANSPLANT OR IMPLANT OF HEART ASSIST SYSTEM.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'104', N'CARDIAC VALVE & OTH MAJOR CARDIOTHORACIC PROC W CARD CATH.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'105', N'CARDIAC VALVE & OTH MAJOR CARDIOTHORACIC PROC W/O CARD CATH.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'106', N'CORONARY BYPASS W PTCA', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'107', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'108', N'OTHER CARDIOTHORACIC PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'109', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'11', N'NERVOUS SYSTEM NEOPLASMS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'110', N'MAJOR CARDIOVASCULAR PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'111', N'MAJOR CARDIOVASCULAR PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'112', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'113', N'AMPUTATION FOR CIRC SYSTEM DISORDERS EXCEPT UPPER LIMB & TOE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'114', N'UPPER LIMB & TOE AMPUTATION FOR CIRC SYSTEM DISORDERS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'115', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'116', N'NO LONGER VALID', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'117', N'CARDIAC PACEMAKER REVISION EXCEPT DEVICE REPLACEMENT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'118', N'CARDIAC PACEMAKER DEVICE REPLACEMENT.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'119', N'VEIN LIGATION & STRIPPING', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'12', N'DEGENERATIVE NERVOUS SYSTEM DISORDERS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'120', N'OTHER CIRCULATORY SYSTEM O.R. PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'121', N'CIRCULATORY DISORDERS W AMI & MAJOR COMP, DISCHARGED ALIVE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'122', N'CIRCULATORY DISORDERS W AMI W/ O MAJOR COMP, DISCHARGED ALIVE.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'123', N'CIRCULATORY DISORDERS W AMI, EXPIRED.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'160', N'HERNIA PROCEDURES EXCEPT INGUINAL & FEMORAL AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'161', N'INGUINAL & FEMORAL HERNIA PROCEDURES AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'162', N'INGUINAL & FEMORAL HERNIA PROCEDURES AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'163', N'HERNIA PROCEDURES AGE 0-17', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'164', N'APPENDECTOMY W COMPLICATED PRINCIPAL DIAG W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'165', N'APPENDECTOMY W COMPLICATED PRINCIPAL DIAG W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'166', N'APPENDECTOMY W/O COMPLICATED PRINCIPAL DIAG W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'167', N'APPENDECTOMY W/O COMPLICATED PRINCIPAL DIAG W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'168', N'MOUTH PROCEDURES W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'169', N'MOUTH PROCEDURES W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'17', N'NONSPECIFIC CEREBROVASCULAR DISORDERS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'170', N'OTHER DIGESTIVE SYSTEM O.R. PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'171', N'OTHER DIGESTIVE SYSTEM O.R. PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'172', N'DIGESTIVE MALIGNANCY W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'173', N'DIGESTIVE MALIGNANCY W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'174', N'G.I. HEMORRHAGE W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'175', N'G.I. HEMORRHAGE W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'176', N'COMPLICATED PEPTIC ULCER', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'177', N'UNCOMPLICATED PEPTIC ULCER W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'178', N'UNCOMPLICATED PEPTIC ULCER W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'179', N'INFLAMMATORY BOWEL DISEASE', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'18', N'CRANIAL & PERIPHERAL NERVE DISORDERS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'180', N'G.I. OBSTRUCTION W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'181', N'G.I. OBSTRUCTION W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'182', N'ESOPHAGITIS, GASTROENT & MISC DIGEST DISORDERS AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'183', N'ESOPHAGITIS, GASTROENT & MISC DIGEST DISORDERS AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'184', N'ESOPHAGITIS, GASTROENT & MISC DIGEST DISORDERS AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'185', N'DENTAL & ORAL DIS EXCEPT EXTRACTIONS & RESTORATIONS, AGE >17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'186', N'DENTAL & ORAL DIS EXCEPT EXTRACTIONS & RESTORATIONS, AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'187', N'DENTAL EXTRACTIONS & RESTORATIONS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'188', N'OTHER DIGESTIVE SYSTEM DIAGNOSES AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'189', N'OTHER DIGESTIVE SYSTEM DIAGNOSES AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'19', N'CRANIAL & PERIPHERAL NERVE DISORDERS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'190', N'OTHER DIGESTIVE SYSTEM DIAGNOSES AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'191', N'PANCREAS, LIVER & SHUNT PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'192', N'PANCREAS, LIVER & SHUNT PROCEDURES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'193', N'BILIARY TRACT PROC EXCEPT ONLY CHOLECYST W OR W/O C.D.E. W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'194', N'BILIARY TRACT PROC EXCEPT ONLY CHOLECYST W OR W/O C.D.E. W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'195', N'CHOLECYSTECTOMY W C.D.E. W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'196', N'CHOLECYSTECTOMY W C.D.E. W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'197', N'CHOLECYSTECTOMY EXCEPT BY LAPAROSCOPE W/O C.D.E. W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'198', N'CHOLECYSTECTOMY EXCEPT BY LAPAROSCOPE W/O C.D.E. W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'199', N'HEPATOBILIARY DIAGNOSTIC PROCEDURE FOR MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2', N'CRANIOTOMY AGE >17 W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'20', N'NERVOUS SYSTEM INFECTION EXCEPT VIRAL MENINGITIS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'200', N'HEPATOBILIARY DIAGNOSTIC PROCEDURE FOR NON-MALIGNANCY.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'201', N'OTHER HEPATOBILIARY OR PANCREAS O.R. PROCEDURES.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'202', N'CIRRHOSIS & ALCOHOLIC HEPATITIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'203', N'MALIGNANCY OF HEPATOBILIARY SYSTEM OR PANCREAS.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'204', N'DISORDERS OF PANCREAS EXCEPT MALIGNANCY.', N'DRGCode')
GO
print 'Processed 900 total records'
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'205', N'DISORDERS OF LIVER EXCEPT MALIG,CIRR,ALC HEPA W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'206', N'DISORDERS OF LIVER EXCEPT MALIG,CIRR,ALC HEPA W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'207', N'DISORDERS OF THE BILIARY TRACT W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1', N'Hospital', N'FacilityTypeCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2', N'Skilled Nursing', N'FacilityTypeCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'3', N'Home Health +', N'FacilityTypeCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'4', N'Religious Non-Medical Health Care Institutions - Hospital Inpatient(formerly referred to as Christian Science)', N'FacilityTypeCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'5', N'Religious Non-Medical Health Care Institutions - Post-Hospital Extended Care Services (formerly referred to as Christian Science)', N'FacilityTypeCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'6', N'Intermediate Care', N'FacilityTypeCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'7', N'Clinic', N'FacilityTypeCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'8', N'Special Facility', N'FacilityTypeCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1', N'Person', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2', N'Non-Person Entity', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'3', N'Unknown', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'4', N'Corporation', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'5', N'Trust', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'6', N'Organization', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'7', N'Limited Liability Corporation', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'8', N'Partnership', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'9', N'S Corporation', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'A', N'Federally Chartered Financial Institution', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'B', N'State Chartered Financial Institution', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'C', N'Custodial', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'D', N'Non-Profit Organization', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'E', N'Sole Proprietorship', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'G', N'Government', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'L', N'Limited Partnership', N'BillingProviderEntityType')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'1', N'Property Conveyance - Mortgagee obtains property through foreclosure or by deed-in-lieu after default ', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'2', N'Mortgage Assignment - Mortgagee assigns mortgage in default to mortgage insurer ', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'3', N'Automatic Mortgage Assignment - Certain insured mortgages not in default assigned to mortgage insurer after 20 years ', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'4', N'Mortgage Coinsurance, Mortgagee acquires property after default and sells; loss on sale is shared by mortgage insurer and mortgagee ', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'5', N'Supplemental Claim, Amendment to application made when additional amounts are owed or due ', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'6', N'Property Nonconveyance (Claim without Conveyance of Title)- Property is not conveyed by the mortgagee- but may be sold to a third party at the foreclosure sale', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'7', N'Property Preforeclosure Sale - Property sold by mortgagor to avoid foreclosure; mortgagee can file a claim for the difference between net sale proceeds and indebtedness ', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'8', N'Initial Claim, First claim filed by the insured for mortgage insurance benefits ', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'9', N'Self-pay', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'10', N'Central Certification', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'11', N'Other Non-Federal Programs', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'12', N'Preferred Provider Organization (PPO)', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'13', N'Point of Service (POS)', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'14', N'Exclusive Provider Organization (EPO)', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'15', N'Indemnity Insurance', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'16', N'Health Maintenance Organization (HMO) Medicare Risk', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'17', N'Dental Maintenance Organization', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'18', N'Deed-in-Lieu Property Sold', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'19', N'Deed-in-Lieu Property Not Sold', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'20', N'Foreclosure Complete Property Sold', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'21', N'Foreclosure Complete Property Not Sold', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'22', N'Liability Insurance', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'31', N'Special Forbearance', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'32', N'Loan Modifications', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'33', N'Partial Claim', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'AM', N'Automobile Medical', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'BL', N'Blue Cross/Blue Shield', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'CH', N'Champus', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'CI', N'Commercial Insurance Co.', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'CN', N'Contractual', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'DS', N'Disability', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'FI', N'Federal Employees Program', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'HM', N'Health Maintenance Organization - There is no map to EMC v.6.0.', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'LI', N'Liability', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'LM', N'Liability Medical', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'MA', N'Medicare Part A', N'ClaimFilingIndicator')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'124', N'CIRCULATORY DISORDERS EXCEPT AMI, W CARD CATH & COMPLEX DIAG.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'125', N'CIRCULATORY DISORDERS EXCEPT AMI, W CARD CATH W/O COMPLEX DIAG.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'126', N'ACUTE & SUBACUTE ENDOCARDITIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'127', N'HEART FAILURE & SHOCK', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'128', N'DEEP VEIN THROMBOPHLEBITIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'129', N'CARDIAC ARREST, UNEXPLAINED', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'13', N'MULTIPLE SCLEROSIS & CEREBELLAR ATAXIA.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'130', N'PERIPHERAL VASCULAR DISORDERS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'131', N'PERIPHERAL VASCULAR DISORDERS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'132', N'ATHEROSCLEROSIS W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'133', N'ATHEROSCLEROSIS W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'134', N'HYPERTENSION', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'135', N'CARDIAC CONGENITAL & VALVULAR DISORDERS AGE >17 W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'136', N'CARDIAC CONGENITAL & VALVULAR DISORDERS AGE >17 W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'137', N'CARDIAC CONGENITAL & VALVULAR DISORDERS AGE 0-17.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'138', N'CARDIAC ARRHYTHMIA & CONDUCTION DISORDERS W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'139', N'CARDIAC ARRHYTHMIA & CONDUCTION DISORDERS W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'14', N'INTRACRANIAL HEMORRHAGE OR CEREBRAL INFARCTION.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'140', N'ANGINA PECTORIS', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'141', N'SYNCOPE & COLLAPSE W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'142', N'SYNCOPE & COLLAPSE W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'143', N'CHEST PAIN', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'144', N'OTHER CIRCULATORY SYSTEM DIAGNOSES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'145', N'OTHER CIRCULATORY SYSTEM DIAGNOSES W/O CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'146', N'RECTAL RESECTION W CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'147', N'RECTAL RESECTION W/O CC', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'148', N'MAJOR SMALL & LARGE BOWEL PROCEDURES W CC.', N'DRGCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ah', N'Received adjudicated EBR from Clearinghouse', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ai', N'Received error EBR from Clearinghouse', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'aj', N'Received adjudicated Realtime Message from Clearinghouse', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'ak', N'Received error Realtime Message from Clearinghouse', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'al', N'Received message EBR from Clearinghouse', N'ClaimProcessingStatusCode')
INSERT [dbo].[LookupValues] ([ID], [Name], [LookupType]) VALUES (N'am', N'Received 997 Acknoledgement', N'ClaimProcessingStatusCode')
